package com.wlgc.mapper;

import com.wlgc.entity.RestBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ClassMapper {
    //获取所有班级
    @Select("select cno from class ")
    List<String> getAllCno();
    //获取某个课程的所有班级
    @Select("select distinct cno from student_course_view where courseName=#{courseName}")
    List<Integer> getCnoByCourseName(@Param("courseName") String courseName);
}
